Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 322773 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 3563 |
| Duplicate rows (%) | 1.1% |
| Total size in memory | 27.1 MiB |
| Average record size in memory | 88.0 B |
Variable types
| Numeric | 11 |
|---|
| Dataset has 3563 (1.1%) duplicate rows | Duplicates |
u is highly correlated with g and 6 other fields | High correlation |
g is highly correlated with u and 7 other fields | High correlation |
r is highly correlated with u and 7 other fields | High correlation |
i is highly correlated with u and 7 other fields | High correlation |
z is highly correlated with u and 7 other fields | High correlation |
uErr is highly correlated with u and 7 other fields | High correlation |
gErr is highly correlated with u and 8 other fields | High correlation |
rErr is highly correlated with u and 8 other fields | High correlation |
iErr is highly correlated with g and 7 other fields | High correlation |
zErr is highly correlated with gErr and 2 other fields | High correlation |
u is highly correlated with g and 5 other fields | High correlation |
g is highly correlated with u and 5 other fields | High correlation |
r is highly correlated with u and 5 other fields | High correlation |
i is highly correlated with u and 5 other fields | High correlation |
z is highly correlated with u and 5 other fields | High correlation |
uErr is highly correlated with u and 5 other fields | High correlation |
gErr is highly correlated with u and 6 other fields | High correlation |
rErr is highly correlated with gErr and 1 other fields | High correlation |
iErr is highly correlated with rErr | High correlation |
u is highly correlated with g and 5 other fields | High correlation |
g is highly correlated with u and 6 other fields | High correlation |
r is highly correlated with u and 6 other fields | High correlation |
i is highly correlated with u and 6 other fields | High correlation |
z is highly correlated with u and 6 other fields | High correlation |
uErr is highly correlated with u and 6 other fields | High correlation |
gErr is highly correlated with u and 7 other fields | High correlation |
rErr is highly correlated with g and 7 other fields | High correlation |
iErr is highly correlated with gErr and 2 other fields | High correlation |
zErr is highly correlated with rErr and 1 other fields | High correlation |
u is highly correlated with g and 4 other fields | High correlation |
g is highly correlated with u and 6 other fields | High correlation |
r is highly correlated with u and 6 other fields | High correlation |
i is highly correlated with u and 5 other fields | High correlation |
z is highly correlated with u and 3 other fields | High correlation |
uErr is highly correlated with u | High correlation |
gErr is highly correlated with g and 3 other fields | High correlation |
rErr is highly correlated with g and 4 other fields | High correlation |
iErr is highly correlated with g and 5 other fields | High correlation |
zErr is highly correlated with iErr | High correlation |
rErr is highly skewed (γ1 = 55.03254176) | Skewed |
iErr is highly skewed (γ1 = 90.4813831) | Skewed |
zErr is highly skewed (γ1 = 173.1138733) | Skewed |
Reproduction
| Analysis started | 2022-02-27 19:47:21.898757 |
|---|---|
| Analysis finished | 2022-02-27 19:47:54.580116 |
| Duration | 32.68 seconds |
| Software version | pandas-profiling v3.1.1 |
| Download configuration | config.json |
ID
Real number (ℝ≥0)
| Distinct | 319208 |
|---|---|
| Distinct (%) | 98.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.237664597 × 1018 |
| Minimum | 1.23764588 × 1018 |
|---|---|
| Maximum | 1.237680531 × 1018 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 1.23764588 × 1018 |
|---|---|
| 5-th percentile | 1.237651497 × 1018 |
| Q1 | 1.237658492 × 1018 |
| median | 1.237663783 × 1018 |
| Q3 | 1.237668298 × 1018 |
| 95-th percentile | 1.237679543 × 1018 |
| Maximum | 1.237680531 × 1018 |
| Range | 3.465177858 × 1013 |
| Interquartile range (IQR) | 9.805951467 × 1012 |
Descriptive statistics
| Standard deviation | 8.395528755 × 1012 |
|---|---|
| Coefficient of variation (CV) | 6.783363419 × 10-6 |
| Kurtosis | -0.5681399988 |
| Mean | 1.237664597 × 1018 |
| Median Absolute Deviation (MAD) | 4.713715729 × 1012 |
| Skewness | 0.3629541432 |
| Sum | 2.025449374 × 1018 |
| Variance | 7.048490308 × 1025 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.237663543 × 1018 | 4 | < 0.1% |
| 1.237663234 × 1018 | 2 | < 0.1% |
| 1.2376786 × 1018 | 2 | < 0.1% |
| 1.237657595 × 1018 | 2 | < 0.1% |
| 1.237660242 × 1018 | 2 | < 0.1% |
| 1.23766829 × 1018 | 2 | < 0.1% |
| 1.23766743 × 1018 | 2 | < 0.1% |
| 1.237648722 × 1018 | 2 | < 0.1% |
| 1.237648722 × 1018 | 2 | < 0.1% |
| 1.237678879 × 1018 | 2 | < 0.1% |
| Other values (319198) | 322751 |
| Value | Count | Frequency (%) |
| 1.23764588 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 |
| Value | Count | Frequency (%) |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 |
| Distinct | 298932 |
|---|---|
| Distinct (%) | 92.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.9556061 |
| Minimum | 11.754014 |
|---|---|
| Maximum | 30.553564 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 11.754014 |
|---|---|
| 5-th percentile | 19.5969708 |
| Q1 | 21.054209 |
| median | 22.023914 |
| Q3 | 22.774895 |
| 95-th percentile | 24.3006932 |
| Maximum | 30.553564 |
| Range | 18.79955 |
| Interquartile range (IQR) | 1.720686 |
Descriptive statistics
| Standard deviation | 1.437346452 |
|---|---|
| Coefficient of variation (CV) | 0.06546603387 |
| Kurtosis | 1.308288606 |
| Mean | 21.9556061 |
| Median Absolute Deviation (MAD) | 0.848509 |
| Skewness | 0.01677101489 |
| Sum | 7086676.847 |
| Variance | 2.065964824 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 22.16309 | 5 | < 0.1% |
| 22.265358 | 5 | < 0.1% |
| 21.833239 | 5 | < 0.1% |
| 23.041296 | 5 | < 0.1% |
| 21.812965 | 5 | < 0.1% |
| 21.646328 | 4 | < 0.1% |
| 23.602564 | 4 | < 0.1% |
| 21.904016 | 4 | < 0.1% |
| 22.750834 | 4 | < 0.1% |
| 23.156593 | 4 | < 0.1% |
| Other values (298922) | 322728 |
| Value | Count | Frequency (%) |
| 11.754014 | 1 | |
| 12.345327 | 1 | |
| 12.458881 | 1 | |
| 13.230087 | 1 | |
| 13.356975 | 1 | |
| 13.587913 | 1 | |
| 13.882559 | 1 | |
| 13.946134 | 1 | |
| 13.984825 | 1 | |
| 14.093331 | 1 |
| Value | Count | Frequency (%) |
| 30.553564 | 1 | |
| 28.827219 | 1 | |
| 28.809177 | 1 | |
| 28.111626 | 1 | |
| 27.910955 | 1 | |
| 27.908926 | 1 | |
| 27.761436 | 1 | |
| 27.746222 | 1 | |
| 27.733286 | 1 | |
| 27.712788 | 1 |
| Distinct | 299157 |
|---|---|
| Distinct (%) | 92.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.19373151 |
| Minimum | 11.576696 |
|---|---|
| Maximum | 30.612074 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 11.576696 |
|---|---|
| 5-th percentile | 17.9577148 |
| Q1 | 19.195459 |
| median | 20.370577 |
| Q3 | 21.164747 |
| 95-th percentile | 22.1619626 |
| Maximum | 30.612074 |
| Range | 19.035378 |
| Interquartile range (IQR) | 1.969288 |
Descriptive statistics
| Standard deviation | 1.348269284 |
|---|---|
| Coefficient of variation (CV) | 0.0667667233 |
| Kurtosis | 0.2008340482 |
| Mean | 20.19373151 |
| Median Absolute Deviation (MAD) | 0.942066 |
| Skewness | -0.385922947 |
| Sum | 6517991.299 |
| Variance | 1.817830062 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 18.903942 | 5 | < 0.1% |
| 21.640287 | 5 | < 0.1% |
| 21.550108 | 5 | < 0.1% |
| 20.772346 | 5 | < 0.1% |
| 21.313578 | 5 | < 0.1% |
| 20.416983 | 5 | < 0.1% |
| 21.074636 | 4 | < 0.1% |
| 19.749283 | 4 | < 0.1% |
| 20.735598 | 4 | < 0.1% |
| 18.640408 | 4 | < 0.1% |
| Other values (299147) | 322727 |
| Value | Count | Frequency (%) |
| 11.576696 | 1 | |
| 12.129926 | 1 | |
| 12.27673 | 1 | |
| 12.551465 | 1 | |
| 12.704343 | 1 | |
| 12.912142 | 1 | |
| 12.922514 | 1 | |
| 12.953435 | 1 | |
| 13.014481 | 1 | |
| 13.034089 | 1 |
| Value | Count | Frequency (%) |
| 30.612074 | 1 | |
| 29.717215 | 1 | |
| 27.497858 | 1 | |
| 26.724417 | 1 | |
| 26.632187 | 1 | |
| 26.397114 | 1 | |
| 26.121351 | 1 | |
| 25.969074 | 1 | |
| 25.873743 | 1 | |
| 25.741123 | 1 |
| Distinct | 296257 |
|---|---|
| Distinct (%) | 91.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.6947964 |
| Minimum | 11.48799 |
|---|---|
| Maximum | 29.998732 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 11.48799 |
|---|---|
| 5-th percentile | 16.9483346 |
| Q1 | 17.80587 |
| median | 18.713923 |
| Q3 | 19.446276 |
| 95-th percentile | 20.5818964 |
| Maximum | 29.998732 |
| Range | 18.510742 |
| Interquartile range (IQR) | 1.640406 |
Descriptive statistics
| Standard deviation | 1.15810765 |
|---|---|
| Coefficient of variation (CV) | 0.06194812855 |
| Kurtosis | 0.1326534155 |
| Mean | 18.6947964 |
| Median Absolute Deviation (MAD) | 0.817866 |
| Skewness | -0.07090050216 |
| Sum | 6034175.517 |
| Variance | 1.34121333 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 18.615803 | 5 | < 0.1% |
| 18.862406 | 5 | < 0.1% |
| 18.731112 | 5 | < 0.1% |
| 18.951262 | 5 | < 0.1% |
| 18.712122 | 5 | < 0.1% |
| 18.734707 | 5 | < 0.1% |
| 18.918041 | 4 | < 0.1% |
| 17.702974 | 4 | < 0.1% |
| 18.843317 | 4 | < 0.1% |
| 18.761862 | 4 | < 0.1% |
| Other values (296247) | 322727 |
| Value | Count | Frequency (%) |
| 11.48799 | 1 | |
| 11.550475 | 1 | |
| 11.657546 | 1 | |
| 11.762335 | 1 | |
| 11.884485 | 1 | |
| 11.946547 | 1 | |
| 12.018159 | 1 | |
| 12.22333 | 1 | |
| 12.245132 | 1 | |
| 12.391564 | 1 |
| Value | Count | Frequency (%) |
| 29.998732 | 1 | |
| 29.346752 | 1 | |
| 27.399418 | 1 | |
| 25.801075 | 1 | |
| 24.835089 | 1 | |
| 24.755783 | 1 | |
| 24.755745 | 1 | |
| 24.750845 | 1 | |
| 24.749956 | 1 | |
| 24.746508 | 1 |
| Distinct | 293614 |
|---|---|
| Distinct (%) | 91.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.06889016 |
| Minimum | 11.023721 |
|---|---|
| Maximum | 29.780376 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 11.023721 |
|---|---|
| 5-th percentile | 16.4923452 |
| Q1 | 17.294764 |
| median | 18.107769 |
| Q3 | 18.757929 |
| 95-th percentile | 19.679493 |
| Maximum | 29.780376 |
| Range | 18.756655 |
| Interquartile range (IQR) | 1.463165 |
Descriptive statistics
| Standard deviation | 1.026973179 |
|---|---|
| Coefficient of variation (CV) | 0.05683653889 |
| Kurtosis | 0.5164648773 |
| Mean | 18.06889016 |
| Median Absolute Deviation (MAD) | 0.731504 |
| Skewness | -0.1562017704 |
| Sum | 5832149.885 |
| Variance | 1.054673909 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 18.741577 | 5 | < 0.1% |
| 17.426584 | 5 | < 0.1% |
| 18.749388 | 5 | < 0.1% |
| 18.375607 | 5 | < 0.1% |
| 17.120773 | 5 | < 0.1% |
| 18.409409 | 5 | < 0.1% |
| 16.943998 | 5 | < 0.1% |
| 18.05155 | 5 | < 0.1% |
| 18.359179 | 5 | < 0.1% |
| 18.372072 | 4 | < 0.1% |
| Other values (293604) | 322724 |
| Value | Count | Frequency (%) |
| 11.023721 | 1 | |
| 11.171733 | 1 | |
| 11.22397 | 1 | |
| 11.303094 | 1 | |
| 11.486779 | 1 | |
| 11.847364 | 1 | |
| 11.913856 | 1 | |
| 11.92277 | 1 | |
| 11.995991 | 1 | |
| 12.019981 | 1 |
| Value | Count | Frequency (%) |
| 29.780376 | 1 | |
| 27.96781 | 1 | |
| 25.775478 | 1 | |
| 24.723509 | 1 | |
| 24.591396 | 1 | |
| 24.410803 | 1 | |
| 24.401884 | 1 | |
| 24.339972 | 1 | |
| 24.338566 | 1 | |
| 24.331234 | 1 |
| Distinct | 292925 |
|---|---|
| Distinct (%) | 90.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.70271177 |
| Minimum | 10.680226 |
|---|---|
| Maximum | 28.568005 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 10.680226 |
|---|---|
| 5-th percentile | 16.1626814 |
| Q1 | 16.960899 |
| median | 17.735628 |
| Q3 | 18.366991 |
| 95-th percentile | 19.2754992 |
| Maximum | 28.568005 |
| Range | 17.887779 |
| Interquartile range (IQR) | 1.406092 |
Descriptive statistics
| Standard deviation | 1.003498809 |
|---|---|
| Coefficient of variation (CV) | 0.05668616322 |
| Kurtosis | 0.7074093405 |
| Mean | 17.70271177 |
| Median Absolute Deviation (MAD) | 0.704908 |
| Skewness | -0.1104614452 |
| Sum | 5713957.385 |
| Variance | 1.007009859 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 16.745577 | 5 | < 0.1% |
| 17.211178 | 5 | < 0.1% |
| 18.095423 | 5 | < 0.1% |
| 18.560989 | 5 | < 0.1% |
| 18.157446 | 5 | < 0.1% |
| 16.892282 | 5 | < 0.1% |
| 17.940506 | 5 | < 0.1% |
| 17.036549 | 4 | < 0.1% |
| 17.5793 | 4 | < 0.1% |
| 17.098827 | 4 | < 0.1% |
| Other values (292915) | 322726 |
| Value | Count | Frequency (%) |
| 10.680226 | 1 | |
| 10.902326 | 1 | |
| 10.932217 | 1 | |
| 10.971477 | 1 | |
| 11.148276 | 1 | |
| 11.52019 | 1 | |
| 11.540811 | 1 | |
| 11.54752 | 1 | |
| 11.591019 | 1 | |
| 11.687567 | 1 |
| Value | Count | Frequency (%) |
| 28.568005 | 1 | |
| 27.737377 | 1 | |
| 24.666559 | 1 | |
| 24.346718 | 1 | |
| 24.117994 | 1 | |
| 23.650806 | 1 | |
| 23.553709 | 1 | |
| 23.539772 | 1 | |
| 23.521828 | 1 | |
| 23.491987 | 1 |
| Distinct | 319208 |
|---|---|
| Distinct (%) | 98.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4093736363 |
| Minimum | 0.01319976295 |
|---|---|
| Maximum | 6.87985948 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 0.01319976295 |
|---|---|
| 5-th percentile | 0.06370328239 |
| Q1 | 0.1791127415 |
| median | 0.3379753453 |
| Q3 | 0.5511080839 |
| 95-th percentile | 1.005467645 |
| Maximum | 6.87985948 |
| Range | 6.866659717 |
| Interquartile range (IQR) | 0.3719953424 |
Descriptive statistics
| Standard deviation | 0.3115871382 |
|---|---|
| Coefficient of variation (CV) | 0.7611314227 |
| Kurtosis | 6.775853907 |
| Mean | 0.4093736363 |
| Median Absolute Deviation (MAD) | 0.177190116 |
| Skewness | 1.779470671 |
| Sum | 132134.7567 |
| Variance | 0.09708654468 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.2168783935 | 4 | < 0.1% |
| 0.6244272516 | 2 | < 0.1% |
| 0.1314960336 | 2 | < 0.1% |
| 0.09819452791 | 2 | < 0.1% |
| 0.6659425862 | 2 | < 0.1% |
| 0.1566778888 | 2 | < 0.1% |
| 0.1839097613 | 2 | < 0.1% |
| 1.036953182 | 2 | < 0.1% |
| 0.2816459403 | 2 | < 0.1% |
| 0.6611182425 | 2 | < 0.1% |
| Other values (319198) | 322751 |
| Value | Count | Frequency (%) |
| 0.01319976295 | 1 | |
| 0.01335124523 | 1 | |
| 0.01373493225 | 1 | |
| 0.01378111571 | 1 | |
| 0.01401705579 | 1 | |
| 0.01419630977 | 1 | |
| 0.0142992412 | 1 | |
| 0.01437876316 | 1 | |
| 0.01441737656 | 1 | |
| 0.01455504511 | 1 |
| Value | Count | Frequency (%) |
| 6.87985948 | 1 | |
| 6.742928143 | 1 | |
| 5.624479585 | 1 | |
| 5.087197718 | 1 | |
| 4.385355573 | 1 | |
| 4.187609544 | 1 | |
| 4.105101217 | 1 | |
| 4.009547602 | 1 | |
| 4.000261639 | 1 | |
| 3.95019859 | 1 |
| Distinct | 319208 |
|---|---|
| Distinct (%) | 98.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.09043704363 |
| Minimum | 0.02266076487 |
|---|---|
| Maximum | 6.429339305 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 0.02266076487 |
|---|---|
| 5-th percentile | 0.03282268764 |
| Q1 | 0.04590849561 |
| median | 0.07180088384 |
| Q3 | 0.109452749 |
| 95-th percentile | 0.2038583536 |
| Maximum | 6.429339305 |
| Range | 6.40667854 |
| Interquartile range (IQR) | 0.06354425342 |
Descriptive statistics
| Standard deviation | 0.08013327711 |
|---|---|
| Coefficient of variation (CV) | 0.8860669688 |
| Kurtosis | 547.4661875 |
| Mean | 0.09043704363 |
| Median Absolute Deviation (MAD) | 0.0292055456 |
| Skewness | 12.60740719 |
| Sum | 29190.63588 |
| Variance | 0.006421342101 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.08912493136 | 4 | < 0.1% |
| 0.1054491528 | 2 | < 0.1% |
| 0.03824290212 | 2 | < 0.1% |
| 0.03250201824 | 2 | < 0.1% |
| 0.1042342052 | 2 | < 0.1% |
| 0.04622961811 | 2 | < 0.1% |
| 0.03800883424 | 2 | < 0.1% |
| 0.1529887296 | 2 | < 0.1% |
| 0.0590374233 | 2 | < 0.1% |
| 0.1013174955 | 2 | < 0.1% |
| Other values (319198) | 322751 |
| Value | Count | Frequency (%) |
| 0.02266076487 | 1 | |
| 0.02282897274 | 1 | |
| 0.02310271782 | 1 | |
| 0.02311547278 | 1 | |
| 0.02314455778 | 1 | |
| 0.02323303193 | 1 | |
| 0.02331523775 | 1 | |
| 0.02333767652 | 1 | |
| 0.02339651578 | 1 | |
| 0.02339853652 | 1 |
| Value | Count | Frequency (%) |
| 6.429339305 | 1 | |
| 6.232147577 | 1 | |
| 5.301634952 | 1 | |
| 5.275434365 | 1 | |
| 4.705393845 | 1 | |
| 4.126417778 | 1 | |
| 3.92779142 | 1 | |
| 3.885418222 | 1 | |
| 3.802731294 | 1 | |
| 3.736464955 | 1 |
| Distinct | 319208 |
|---|---|
| Distinct (%) | 98.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07348899497 |
| Minimum | 0.03485844218 |
|---|---|
| Maximum | 7.180163959 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 0.03485844218 |
|---|---|
| 5-th percentile | 0.04587236738 |
| Q1 | 0.05382458467 |
| median | 0.06389599803 |
| Q3 | 0.0816330393 |
| 95-th percentile | 0.1338392608 |
| Maximum | 7.180163959 |
| Range | 7.145305517 |
| Interquartile range (IQR) | 0.02780845462 |
Descriptive statistics
| Standard deviation | 0.0422274164 |
|---|---|
| Coefficient of variation (CV) | 0.5746087073 |
| Kurtosis | 7054.017881 |
| Mean | 0.07348899497 |
| Median Absolute Deviation (MAD) | 0.01212842808 |
| Skewness | 55.03254176 |
| Sum | 23720.26337 |
| Variance | 0.001783154696 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.05969741486 | 4 | < 0.1% |
| 0.07771899697 | 2 | < 0.1% |
| 0.05081076871 | 2 | < 0.1% |
| 0.04610985186 | 2 | < 0.1% |
| 0.08805127314 | 2 | < 0.1% |
| 0.05429979497 | 2 | < 0.1% |
| 0.0475555689 | 2 | < 0.1% |
| 0.1168620691 | 2 | < 0.1% |
| 0.05657002376 | 2 | < 0.1% |
| 0.06814908981 | 2 | < 0.1% |
| Other values (319198) | 322751 |
| Value | Count | Frequency (%) |
| 0.03485844218 | 1 | |
| 0.03535379817 | 1 | |
| 0.03542247378 | 1 | |
| 0.03582003744 | 1 | |
| 0.03587685256 | 1 | |
| 0.0359197515 | 1 | |
| 0.0359423393 | 1 | |
| 0.03598042238 | 1 | |
| 0.03598916294 | 1 | |
| 0.03607572236 | 1 |
| Value | Count | Frequency (%) |
| 7.180163959 | 1 | |
| 6.165068051 | 1 | |
| 5.855121474 | 1 | |
| 4.779347244 | 1 | |
| 4.763801336 | 1 | |
| 4.742747477 | 1 | |
| 4.199696884 | 1 | |
| 4.054225263 | 1 | |
| 3.081155927 | 1 | |
| 2.784959056 | 1 |
| Distinct | 319208 |
|---|---|
| Distinct (%) | 98.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.08095603334 |
| Minimum | 0.03881203054 |
|---|---|
| Maximum | 8.400347923 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 0.03881203054 |
|---|---|
| 5-th percentile | 0.05670971592 |
| Q1 | 0.06526179428 |
| median | 0.07463134987 |
| Q3 | 0.08888451992 |
| 95-th percentile | 0.1233465462 |
| Maximum | 8.400347923 |
| Range | 8.361535893 |
| Interquartile range (IQR) | 0.02362272564 |
Descriptive statistics
| Standard deviation | 0.04799436577 |
|---|---|
| Coefficient of variation (CV) | 0.5928448294 |
| Kurtosis | 12336.67803 |
| Mean | 0.08095603334 |
| Median Absolute Deviation (MAD) | 0.01094209425 |
| Skewness | 90.4813831 |
| Sum | 26130.42175 |
| Variance | 0.002303459146 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.07584420229 | 4 | < 0.1% |
| 0.08010949307 | 2 | < 0.1% |
| 0.06529411125 | 2 | < 0.1% |
| 0.05484251777 | 2 | < 0.1% |
| 0.09859519663 | 2 | < 0.1% |
| 0.0693668594 | 2 | < 0.1% |
| 0.06218602679 | 2 | < 0.1% |
| 0.1131849576 | 2 | < 0.1% |
| 0.06645918173 | 2 | < 0.1% |
| 0.073400088 | 2 | < 0.1% |
| Other values (319198) | 322751 |
| Value | Count | Frequency (%) |
| 0.03881203054 | 1 | |
| 0.04270086665 | 1 | |
| 0.04301709522 | 1 | |
| 0.04312907944 | 1 | |
| 0.04348102676 | 1 | |
| 0.04363486267 | 1 | |
| 0.04377561951 | 1 | |
| 0.04385961229 | 1 | |
| 0.04397806812 | 1 | |
| 0.04398176805 | 1 |
| Value | Count | Frequency (%) |
| 8.400347923 | 1 | |
| 8.038223374 | 1 | |
| 7.864687125 | 1 | |
| 6.48909048 | 1 | |
| 5.962899652 | 1 | |
| 5.953983347 | 1 | |
| 5.799106136 | 1 | |
| 5.697022025 | 1 | |
| 5.422591777 | 1 | |
| 4.829551119 | 1 |
| Distinct | 319208 |
|---|---|
| Distinct (%) | 98.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1168094872 |
| Minimum | 0.04474935232 |
|---|---|
| Maximum | 29.87530183 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 0.04474935232 |
|---|---|
| 5-th percentile | 0.07541463688 |
| Q1 | 0.09083066469 |
| median | 0.106584126 |
| Q3 | 0.1293160932 |
| 95-th percentile | 0.1848991822 |
| Maximum | 29.87530183 |
| Range | 29.83055248 |
| Interquartile range (IQR) | 0.03848542855 |
Descriptive statistics
| Standard deviation | 0.08975594519 |
|---|---|
| Coefficient of variation (CV) | 0.7683960211 |
| Kurtosis | 48683.61816 |
| Mean | 0.1168094872 |
| Median Absolute Deviation (MAD) | 0.01812983916 |
| Skewness | 173.1138733 |
| Sum | 37702.94861 |
| Variance | 0.008056129696 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.1166617016 | 4 | < 0.1% |
| 0.1344127506 | 2 | < 0.1% |
| 0.09536075214 | 2 | < 0.1% |
| 0.07794479662 | 2 | < 0.1% |
| 0.1424054559 | 2 | < 0.1% |
| 0.09076947526 | 2 | < 0.1% |
| 0.08781457829 | 2 | < 0.1% |
| 0.1720696896 | 2 | < 0.1% |
| 0.09949750527 | 2 | < 0.1% |
| 0.0976950293 | 2 | < 0.1% |
| Other values (319198) | 322751 |
| Value | Count | Frequency (%) |
| 0.04474935232 | 1 | |
| 0.04565870618 | 1 | |
| 0.04893893067 | 1 | |
| 0.04904532431 | 1 | |
| 0.04920480286 | 1 | |
| 0.04923784125 | 1 | |
| 0.04937254716 | 1 | |
| 0.04937580216 | 1 | |
| 0.0493958452 | 1 | |
| 0.04942044052 | 1 |
| Value | Count | Frequency (%) |
| 29.87530183 | 1 | |
| 20.34444513 | 1 | |
| 15.39946874 | 1 | |
| 9.034809081 | 1 | |
| 8.540151462 | 1 | |
| 4.74786487 | 1 | |
| 4.196299858 | 1 | |
| 3.807162722 | 1 | |
| 3.493246011 | 1 | |
| 3.492410546 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| ID | u | g | r | i | z | uErr | gErr | rErr | iErr | zErr | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1237645942905110768 | 22.373924 | 20.301023 | 18.914286 | 18.431997 | 18.159517 | 0.312667 | 0.053221 | 0.051427 | 0.055731 | 0.075440 |
| 1 | 1237645942905569773 | 22.497066 | 20.952272 | 19.394960 | 18.853279 | 18.434809 | 0.542727 | 0.115557 | 0.079184 | 0.079735 | 0.109295 |
| 2 | 1237645943978328381 | 22.678976 | 21.650578 | 19.886253 | 19.214005 | 18.839323 | 0.529001 | 0.153088 | 0.088523 | 0.088252 | 0.112267 |
| 3 | 1237645943978524819 | 21.032383 | 18.865986 | 17.561859 | 17.133131 | 16.829306 | 0.179582 | 0.040455 | 0.049065 | 0.059050 | 0.074079 |
| 4 | 1237645943978524889 | 21.576267 | 20.216810 | 18.495819 | 17.974495 | 17.614441 | 0.257184 | 0.067614 | 0.056028 | 0.063211 | 0.076636 |
| 5 | 1237645943978590518 | 21.165874 | 19.130669 | 17.668627 | 17.227806 | 16.949409 | 0.267951 | 0.055352 | 0.059208 | 0.070057 | 0.091337 |
| 6 | 1237645943978590761 | 23.827118 | 22.266033 | 20.510069 | 19.850769 | 19.492815 | 0.725661 | 0.199855 | 0.098939 | 0.093719 | 0.125562 |
| 7 | 1237645943978656051 | 21.894428 | 20.380268 | 18.853308 | 18.346809 | 17.944668 | 0.350742 | 0.076074 | 0.061399 | 0.066141 | 0.161078 |
| 8 | 1237645943978721502 | 22.077801 | 20.384060 | 19.022602 | 18.587086 | 18.295713 | 0.342619 | 0.065458 | 0.058150 | 0.065043 | 0.079621 |
| 9 | 1237645943978721546 | 21.390770 | 20.250340 | 18.936052 | 18.488092 | 18.206268 | 0.244976 | 0.073216 | 0.065740 | 0.072660 | 0.089991 |
Last rows
| ID | u | g | r | i | z | uErr | gErr | rErr | iErr | zErr | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 322763 | 1237680530815255780 | 24.336834 | 21.418812 | 19.511326 | 18.806894 | 18.356859 | 1.048435 | 0.114328 | 0.078506 | 0.088951 | 0.102196 |
| 322764 | 1237680530815713981 | 23.457827 | 21.231998 | 19.377743 | 18.688829 | 18.210978 | 0.960536 | 0.124057 | 0.082271 | 0.093221 | 0.116708 |
| 322765 | 1237680530816500748 | 22.759562 | 21.769369 | 20.680836 | 19.656219 | 19.288139 | 0.785910 | 0.217212 | 0.211030 | 0.181929 | 0.238482 |
| 322766 | 1237680530816631981 | 23.903332 | 22.321108 | 20.874950 | 19.793472 | 19.283394 | 1.168363 | 0.279190 | 0.206576 | 0.163526 | 0.209199 |
| 322767 | 1237680530817418390 | 22.273611 | 20.699070 | 19.874216 | 19.129982 | 18.757246 | 0.719786 | 0.132274 | 0.174994 | 0.186624 | 0.240496 |
| 322768 | 1237680530817483117 | 25.541300 | 21.284241 | 19.378674 | 18.579559 | 18.137300 | 0.904565 | 0.217660 | 0.152072 | 0.166066 | 0.193869 |
| 322769 | 1237680530819187411 | 26.020273 | 21.844044 | 20.219097 | 19.308535 | 18.892942 | 0.481163 | 0.199816 | 0.142057 | 0.139065 | 0.175742 |
| 322770 | 1237680530819253214 | 22.185659 | 23.075047 | 21.338875 | 20.104506 | 19.579048 | 0.287064 | 0.348883 | 0.204575 | 0.146878 | 0.196234 |
| 322771 | 1237680531354420253 | 25.849159 | 22.017805 | 20.328970 | 19.440924 | 18.843649 | 0.412766 | 0.221041 | 0.147098 | 0.140861 | 0.159505 |
| 322772 | 1237680531356320501 | 21.989624 | 21.693808 | 20.043190 | 19.104773 | 18.551073 | 0.347256 | 0.134724 | 0.104478 | 0.100372 | 0.123098 |
Most frequently occurring
| ID | u | g | r | i | z | uErr | gErr | rErr | iErr | zErr | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1731 | 1237663542602564601 | 21.026691 | 18.857670 | 17.338581 | 16.840019 | 16.449909 | 0.216878 | 0.089125 | 0.059697 | 0.075844 | 0.116662 | 4 |
| 0 | 1237645942906028449 | 21.850529 | 20.184954 | 18.965904 | 18.445271 | 18.076197 | 0.581425 | 0.112205 | 0.090856 | 0.087133 | 0.109643 | 2 |
| 1 | 1237646796527239852 | 20.616611 | 18.674509 | 17.407104 | 16.911766 | 16.574181 | 0.116371 | 0.035972 | 0.053232 | 0.070018 | 0.111634 | 2 |
| 2 | 1237648702970855859 | 23.434650 | 21.329880 | 19.620071 | 18.842430 | 18.483221 | 0.768741 | 0.122461 | 0.080214 | 0.081442 | 0.107459 | 2 |
| 3 | 1237648702972625309 | 23.720266 | 21.797260 | 19.910536 | 19.112181 | 18.783051 | 0.787421 | 0.160122 | 0.083411 | 0.080341 | 0.116465 | 2 |
| 4 | 1237648702975771001 | 21.232491 | 20.077679 | 18.534039 | 17.846296 | 17.406675 | 0.175936 | 0.070983 | 0.065820 | 0.074197 | 0.097746 | 2 |
| 5 | 1237648702981997487 | 22.862774 | 21.176657 | 19.878614 | 19.159809 | 18.860010 | 0.364718 | 0.082466 | 0.067082 | 0.072487 | 0.091469 | 2 |
| 6 | 1237648703513690461 | 21.849968 | 19.706116 | 18.333681 | 17.693560 | 17.293987 | 0.271568 | 0.051402 | 0.055969 | 0.062158 | 0.085211 | 2 |
| 7 | 1237648703521882879 | 23.207102 | 21.386423 | 19.839506 | 19.058573 | 18.665577 | 0.589911 | 0.101036 | 0.072775 | 0.068403 | 0.093829 | 2 |
| 8 | 1237648703524176415 | 20.684530 | 19.186924 | 17.807131 | 17.327969 | 16.973257 | 0.140550 | 0.047428 | 0.054187 | 0.061458 | 0.081021 | 2 |